SELECT mstBrand.strBrand AS Brand, dwfPromo.strActivityType AS Type, dwfPromo.strActivityName AS Name, dwfPromo.strChannelPrimary AS Channel
FROM dwfPromo INNER JOIN mstBrand ON dwfPromo.refBrandID = mstBrand.BrandID
WHERE dwfPromo.strPeriod >= '201901'
GROUP BY mstBrand.strBrand, dwfPromo.strActivityType, dwfPromo.strActivityName, dwfPromo.strChannelPrimary